Pandas Profiling Report

Dataset statistics

Number of variables	12
Number of observations	5706
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	579.5 KiB
Average record size in memory	104.0 B

Variable types

Numeric	12

Alerts

`recency` is highly overall correlated with `purchase_count`	High correlation
`avg_purchase_interval` is highly overall correlated with `purchase_count`	High correlation
`nunique_products` is highly overall correlated with `avg_basket_size` and 2 other fields	High correlation
`avg_basket_size` is highly overall correlated with `nunique_products` and 2 other fields	High correlation
`purchase_count` is highly overall correlated with `recency` and 4 other fields	High correlation
`charge_back_count` is highly overall correlated with `purchase_count` and 1 other fields	High correlation
`return_rate` is highly overall correlated with `purchase_count` and 1 other fields	High correlation
`avg_order_value` is highly overall correlated with `nunique_products` and 2 other fields	High correlation
`gross_revenue` is highly overall correlated with `nunique_products` and 3 other fields	High correlation
`avg_unt_price` is highly skewed (γ1 = 40.05551367)	Skewed
`avg_order_value` is highly skewed (γ1 = 21.75818136)	Skewed
`gross_revenue` is highly skewed (γ1 = 23.73500315)	Skewed
`customer_id` has unique values	Unique
`charge_back_count` has 4199 (73.6%) zeros	Zeros
`return_rate` has 4199 (73.6%) zeros	Zeros

Reproduction

Analysis started	2023-05-29 19:33:07.911097
Analysis finished	2023-05-29 19:33:31.906088
Duration	23.99 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

customer_id
Real number (ℝ)

Distinct	5706
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	11208.74

Minimum	-3710
Maximum	18287
Zeros	0
Zeros (%)	0.0%
Negative	1371
Negative (%)	24.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	-3710
5-th percentile	-2747
Q1	12415.5
median	14365.5
Q3	16317.75
95-th percentile	17892.75
Maximum	18287
Range	21997
Interquartile range (IQR)	3902.25

Descriptive statistics

Standard deviation	7446.2304
Coefficient of variation (CV)	0.66432358
Kurtosis	-0.5736743
Mean	11208.74
Median Absolute Deviation (MAD)	1951.5
Skewness	-1.0929403
Sum	63957071
Variance	55446347
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17850	1	< 0.1%
-2087	1	< 0.1%
14053	1	< 0.1%
16009	1	< 0.1%
12922	1	< 0.1%
-2098	1	< 0.1%
16589	1	< 0.1%
13730	1	< 0.1%
16866	1	< 0.1%
-2096	1	< 0.1%
Other values (5696)	5696	99.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-3710	1	< 0.1%
-3709	1	< 0.1%
-3708	1	< 0.1%
-3707	1	< 0.1%
-3706	1	< 0.1%
-3705	1	< 0.1%
-3701	1	< 0.1%
-3700	1	< 0.1%
-3697	1	< 0.1%
-3696	1	< 0.1%

Value	Count	Frequency (%)
18287	1	< 0.1%
18283	1	< 0.1%
18282	1	< 0.1%
18281	1	< 0.1%
18280	1	< 0.1%
18278	1	< 0.1%
18277	1	< 0.1%
18276	1	< 0.1%
18274	1	< 0.1%
18273	1	< 0.1%

lifetime
Real number (ℝ)

Distinct	305
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	216.153

Minimum	0
Maximum	373
Zeros	4
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	0
5-th percentile	24
Q1	109
median	238
Q3	318
95-th percentile	369
Maximum	373
Range	373
Interquartile range (IQR)	209

Descriptive statistics

Standard deviation	116.57112
Coefficient of variation (CV)	0.53929913
Kurtosis	-1.2334936
Mean	216.153
Median Absolute Deviation (MAD)	96
Skewness	-0.29342833
Sum	1233369
Variance	13588.827
Monotonicity	Decreasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
373	101	1.8%
372	98	1.7%
366	88	1.5%
368	78	1.4%
365	76	1.3%
369	70	1.2%
358	66	1.2%
367	61	1.1%
371	57	1.0%
359	46	0.8%
Other values (295)	4965	87.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4	0.1%
1	11	0.2%
2	7	0.1%
3	13	0.2%
4	18	0.3%
5	9	0.2%
7	13	0.2%
8	6	0.1%
9	14	0.2%
10	21	0.4%

Value	Count	Frequency (%)
373	101	1.8%
372	98	1.7%
371	57	1.0%
369	70	1.2%
368	78	1.4%
367	61	1.1%
366	88	1.5%
365	76	1.3%
364	45	0.8%
362	32	0.6%

recency
Real number (ℝ)

Distinct	304
Distinct (%)	5.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	116.90536

Minimum	0
Maximum	373
Zeros	38
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	0
5-th percentile	3
Q1	23
median	71
Q3	199.75
95-th percentile	338
Maximum	373
Range	373
Interquartile range (IQR)	176.75

Descriptive statistics

Standard deviation	111.57499
Coefficient of variation (CV)	0.9544044
Kurtosis	-0.63999466
Mean	116.90536
Median Absolute Deviation (MAD)	61
Skewness	0.81457626
Sum	667062
Variance	12448.979
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	110	1.9%
4	105	1.8%
3	98	1.7%
2	92	1.6%
10	86	1.5%
8	82	1.4%
9	79	1.4%
17	79	1.4%
7	78	1.4%
15	67	1.2%
Other values (294)	4830	84.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38	0.7%
1	110	1.9%
2	92	1.6%
3	98	1.7%
4	105	1.8%
5	52	0.9%
7	78	1.4%
8	82	1.4%
9	79	1.4%
10	86	1.5%

Value	Count	Frequency (%)
373	23	0.4%
372	23	0.4%
371	17	0.3%
369	4	0.1%
368	13	0.2%
367	16	0.3%
366	15	0.3%
365	19	0.3%
364	11	0.2%
362	7	0.1%

avg_purchase_interval
Real number (ℝ)

Distinct	1242
Distinct (%)	21.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.389285

Minimum	0.66666667
Maximum	186.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	0.66666667
5-th percentile	1
Q1	1
median	12.372414
Q3	53.107143
95-th percentile	128
Maximum	186.5
Range	185.83333
Interquartile range (IQR)	52.107143

Descriptive statistics

Standard deviation	44.234909
Coefficient of variation (CV)	1.3248235
Kurtosis	1.760834
Mean	33.389285
Median Absolute Deviation (MAD)	11.372414
Skewness	1.5287103
Sum	190519.26
Variance	1956.7272
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2673	46.8%
62	15	0.3%
30	15	0.3%
92	14	0.2%
186	14	0.2%
53	13	0.2%
16.5	12	0.2%
26	12	0.2%
90	11	0.2%
39	11	0.2%
Other values (1232)	2916	51.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.6666666667	1	< 0.1%
1	2673	46.8%
1.534979424	1	< 0.1%
1.718894009	1	< 0.1%
2.207100592	1	< 0.1%
2.25	1	< 0.1%
2.5	1	< 0.1%
2.96031746	1	< 0.1%
3	1	< 0.1%
3.127118644	1	< 0.1%

Value	Count	Frequency (%)
186.5	11	0.2%
186	14	0.2%
185.5	5	0.1%
184.5	11	0.2%
184	8	0.1%
183.5	4	0.1%
183	7	0.1%
182.5	10	0.2%
182	4	0.1%
181	2	< 0.1%

nunique_products
Real number (ℝ)

Distinct	439
Distinct (%)	7.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	69.617596

Minimum	1
Maximum	1786
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	1
5-th percentile	2
Q1	13
median	36
Q3	84
95-th percentile	241
Maximum	1786
Range	1785
Interquartile range (IQR)	71

Descriptive statistics

Standard deviation	101.64794
Coefficient of variation (CV)	1.4600897
Kurtosis	43.951941
Mean	69.617596
Median Absolute Deviation (MAD)	28
Skewness	4.7072082
Sum	397238
Variance	10332.303
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	279	4.9%
2	149	2.6%
3	113	2.0%
10	101	1.8%
5	98	1.7%
9	96	1.7%
6	93	1.6%
8	93	1.6%
11	93	1.6%
4	90	1.6%
Other values (429)	4501	78.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	279	4.9%
2	149	2.6%
3	113	2.0%
4	90	1.6%
5	98	1.7%
6	93	1.6%
7	90	1.6%
8	93	1.6%
9	96	1.7%
10	101	1.8%

Value	Count	Frequency (%)
1786	1	< 0.1%
1766	1	< 0.1%
1322	1	< 0.1%
1118	1	< 0.1%
1109	1	< 0.1%
884	1	< 0.1%
817	1	< 0.1%
748	1	< 0.1%
730	1	< 0.1%
720	1	< 0.1%

avg_basket_size
Real number (ℝ)

Distinct	2490
Distinct (%)	43.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	224.98652

Minimum	-140.5
Maximum	14149
Zeros	12
Zeros (%)	0.2%
Negative	3
Negative (%)	0.1%
Memory size	89.2 KiB

Quantile statistics

Minimum	-140.5
5-th percentile	4
Q1	65.406061
median	133.5
Q3	257
95-th percentile	668.5
Maximum	14149
Range	14289.5
Interquartile range (IQR)	191.59394

Descriptive statistics

Standard deviation	419.32137
Coefficient of variation (CV)	1.8637622
Kurtosis	450.27512
Mean	224.98652
Median Absolute Deviation (MAD)	84.5
Skewness	16.009513
Sum	1283773.1
Variance	175830.42
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	114	2.0%
2	70	1.2%
3	52	0.9%
4	49	0.9%
5	35	0.6%
6	29	0.5%
12	27	0.5%
72	24	0.4%
7	21	0.4%
120	20	0.4%
Other values (2480)	5265	92.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-140.5	1	< 0.1%
-101	1	< 0.1%
-44	1	< 0.1%
0	12	0.2%
0.25	1	< 0.1%
0.6666666667	1	< 0.1%
1	114	2.0%
2	70	1.2%
3	52	0.9%
3.333333333	1	< 0.1%

Value	Count	Frequency (%)
14149	1	< 0.1%
13956	1	< 0.1%
7824	1	< 0.1%
5963	1	< 0.1%
5197	1	< 0.1%
4300	1	< 0.1%
4280	1	< 0.1%
4136	1	< 0.1%
3206.083333	1	< 0.1%
3028	1	< 0.1%

purchase_count
Real number (ℝ)

Distinct	63
Distinct (%)	1.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.0553803

Minimum	1
Maximum	243
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	14
Maximum	243
Range	242
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	8.1309021
Coefficient of variation (CV)	2.0049666
Kurtosis	274.18899
Mean	4.0553803
Median Absolute Deviation (MAD)	1
Skewness	12.593167
Sum	23140
Variance	66.111569
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	2672	46.8%
2	812	14.2%
3	490	8.6%
4	381	6.7%
5	283	5.0%
6	195	3.4%
7	152	2.7%
8	117	2.1%
9	80	1.4%
10	73	1.3%
Other values (53)	451	7.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	2672	46.8%
2	812	14.2%
3	490	8.6%
4	381	6.7%
5	283	5.0%
6	195	3.4%
7	152	2.7%
8	117	2.1%
9	80	1.4%
10	73	1.3%

Value	Count	Frequency (%)
243	1	< 0.1%
217	1	< 0.1%
169	1	< 0.1%
126	1	< 0.1%
118	2	< 0.1%
88	1	< 0.1%
75	1	< 0.1%
73	1	< 0.1%
66	1	< 0.1%
65	1	< 0.1%

charge_back_count
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	23
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.58762706

Minimum	0
Maximum	45
Zeros	4199
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	1
95-th percentile	3
Maximum	45
Range	45
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.7490544
Coefficient of variation (CV)	2.9764702
Kurtosis	190.73026
Mean	0.58762706
Median Absolute Deviation (MAD)	0
Skewness	10.274232
Sum	3353
Variance	3.0591913
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
0	4199	73.6%
1	852	14.9%
2	289	5.1%
3	140	2.5%
4	92	1.6%
5	37	0.6%
6	32	0.6%
7	21	0.4%
9	8	0.1%
10	5	0.1%
Other values (13)	31	0.5%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4199	73.6%
1	852	14.9%
2	289	5.1%
3	140	2.5%
4	92	1.6%
5	37	0.6%
6	32	0.6%
7	21	0.4%
8	5	0.1%
9	8	0.1%

Value	Count	Frequency (%)
45	1	< 0.1%
44	1	< 0.1%
35	1	< 0.1%
27	1	< 0.1%
21	1	< 0.1%
18	2	< 0.1%
17	1	< 0.1%
15	2	< 0.1%
14	1	< 0.1%
13	5	0.1%

return_rate
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	143
Distinct (%)	2.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	0.076905605

Minimum	0
Maximum	0.75
Zeros	4199
Zeros (%)	73.6%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0.090909091
95-th percentile	0.5
Maximum	0.75
Range	0.75
Interquartile range (IQR)	0.090909091

Descriptive statistics

Standard deviation	0.14837871
Coefficient of variation (CV)	1.9293615
Kurtosis	2.5147132
Mean	0.076905605
Median Absolute Deviation (MAD)	0
Skewness	1.8858298
Sum	438.82338
Variance	0.022016242
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	4199	73.6%
0.5	246	4.3%
0.3333333333	212	3.7%
0.25	165	2.9%
0.2	139	2.4%
0.1666666667	78	1.4%
0.1428571429	61	1.1%
0.4	55	1.0%
0.125	46	0.8%
0.2857142857	40	0.7%
Other values (133)	465	8.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	4199	73.6%
0.01369863014	1	< 0.1%
0.02222222222	1	< 0.1%
0.02272727273	1	< 0.1%
0.02631578947	1	< 0.1%
0.02857142857	1	< 0.1%
0.0303030303	1	< 0.1%
0.03225806452	1	< 0.1%
0.03333333333	1	< 0.1%
0.03448275862	1	< 0.1%

Value	Count	Frequency (%)
0.75	1	< 0.1%
0.7142857143	1	< 0.1%
0.6666666667	19	0.3%
0.6	14	0.2%
0.5714285714	5	0.1%
0.5555555556	2	< 0.1%
0.5454545455	2	< 0.1%
0.5	246	4.3%
0.4736842105	1	< 0.1%
0.4615384615	4	0.1%

avg_unt_price
Real number (ℝ)

Distinct	5276
Distinct (%)	92.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.7139415

Minimum	0.06
Maximum	434.65
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	89.2 KiB

Quantile statistics

Minimum	0.06
5-th percentile	1.2515888
Q1	2.2175
median	3.0467987
Q3	4.25
95-th percentile	6.6969669
Maximum	434.65
Range	434.59
Interquartile range (IQR)	2.0325

Descriptive statistics

Standard deviation	7.8417661
Coefficient of variation (CV)	2.1114404
Kurtosis	1956.3654
Mean	3.7139415
Median Absolute Deviation (MAD)	0.95800549
Skewness	40.055514
Sum	21191.75
Variance	61.493296
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1.25	26	0.5%
4.95	20	0.4%
0.85	18	0.3%
3.75	16	0.3%
2.95	15	0.3%
1.65	14	0.2%
0.42	13	0.2%
2.08	13	0.2%
12.75	12	0.2%
2.55	12	0.2%
Other values (5266)	5547	97.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.06	1	< 0.1%
0.1225	1	< 0.1%
0.17	2	< 0.1%
0.2327777778	1	< 0.1%
0.29	2	< 0.1%
0.32	1	< 0.1%
0.33	1	< 0.1%
0.355	2	< 0.1%
0.358	1	< 0.1%
0.3666666667	1	< 0.1%

Value	Count	Frequency (%)
434.65	1	< 0.1%
295	1	< 0.1%
125	1	< 0.1%
110	2	< 0.1%
74.975	1	< 0.1%
66.475	1	< 0.1%
59.73333333	1	< 0.1%
54.3	1	< 0.1%
51.71	1	< 0.1%
39.95	1	< 0.1%

avg_order_value
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5467
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	511.8143

Minimum	-398.43
Maximum	52940.94
Zeros	5
Zeros (%)	0.1%
Negative	8
Negative (%)	0.1%
Memory size	89.2 KiB

Quantile statistics

Minimum	-398.43
5-th percentile	12.4125
Q1	140.35411
median	248.225
Q3	433.735
95-th percentile	1774.885
Maximum	52940.94
Range	53339.37
Interquartile range (IQR)	293.38089

Descriptive statistics

Standard deviation	1354.2907
Coefficient of variation (CV)	2.6460587
Kurtosis	746.59792
Mean	511.8143
Median Absolute Deviation (MAD)	131.63667
Skewness	21.758181
Sum	2920412.4
Variance	1834103.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
1.25	8	0.1%
2.95	8	0.1%
3.75	8	0.1%
4.95	8	0.1%
1.65	7	0.1%
12.75	7	0.1%
5.95	6	0.1%
7.5	6	0.1%
4.25	6	0.1%
Other values (5457)	5633	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-398.43	1	< 0.1%
-47.16	1	< 0.1%
-31.97666667	1	< 0.1%
-1.136868377 × 10^-13	1	< 0.1%
-5.684341886 × 10^-14	1	< 0.1%
-2.842170943 × 10^-14	1	< 0.1%
-1.421085472 × 10^-14	2	< 0.1%
0	5	0.1%
2.842170943 × 10^-14	1	< 0.1%
2.273736754 × 10^-13	1	< 0.1%

Value	Count	Frequency (%)
52940.94	1	< 0.1%
50653.91	1	< 0.1%
21389.6	1	< 0.1%
18745.86	1	< 0.1%
14855.53	1	< 0.1%
12681.58	1	< 0.1%
12633.67	1	< 0.1%
12172.09	1	< 0.1%
11540.34	1	< 0.1%
10661.69	1	< 0.1%

gross_revenue
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	5465
Distinct (%)	95.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1718.8394

Minimum	-796.86
Maximum	278778.02
Zeros	5
Zeros (%)	0.1%
Negative	8
Negative (%)	0.1%
Memory size	89.2 KiB

Quantile statistics

Minimum	-796.86
5-th percentile	12.46
Q1	230.2875
median	603.17
Q3	1544.6075
95-th percentile	5188.815
Maximum	278778.02
Range	279574.88
Interquartile range (IQR)	1314.32

Descriptive statistics

Standard deviation	7358.9531
Coefficient of variation (CV)	4.28135
Kurtosis	741.04642
Mean	1718.8394
Median Absolute Deviation (MAD)	474.185
Skewness	23.735003
Sum	9807697.7
Variance	54154191
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7.95	9	0.2%
4.95	8	0.1%
1.25	8	0.1%
2.95	8	0.1%
1.65	7	0.1%
12.75	7	0.1%
3.75	7	0.1%
4.25	6	0.1%
7.5	6	0.1%
5.95	6	0.1%
Other values (5455)	5634	98.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-796.86	1	< 0.1%
-141.48	1	< 0.1%
-95.93	1	< 0.1%
-2.273736754 × 10^-13	1	< 0.1%
-1.136868377 × 10^-13	1	< 0.1%
-5.684341886 × 10^-14	1	< 0.1%
-2.842170943 × 10^-14	2	< 0.1%
0	5	0.1%
5.684341886 × 10^-14	1	< 0.1%
4.547473509 × 10^-13	1	< 0.1%

Value	Count	Frequency (%)
278778.02	1	< 0.1%
259657.3	1	< 0.1%
189735.53	1	< 0.1%
133007.13	1	< 0.1%
123638.18	1	< 0.1%
114505.32	1	< 0.1%
88138.2	1	< 0.1%
65920.12	1	< 0.1%
62924.1	1	< 0.1%
59419.34	1	< 0.1%

Auto

Heatmap
Table

	customer_id	lifetime	recency	avg_purchase_interval	nunique_products	avg_basket_size	purchase_count	charge_back_count	return_rate	avg_unt_price	avg_order_value	gross_revenue
customer_id	1.000	0.142	-0.236	0.396	0.007	0.025	0.398	0.219	0.214	-0.233	-0.095	0.092
lifetime	0.142	1.000	0.232	0.393	0.196	-0.057	0.436	0.289	0.233	0.035	-0.022	0.282
recency	-0.236	0.232	1.000	-0.299	-0.326	-0.179	-0.575	-0.329	-0.269	0.203	-0.067	-0.425
avg_purchase_interval	0.396	0.393	-0.299	1.000	0.200	0.036	0.733	0.365	0.398	-0.149	-0.054	0.332
nunique_products	0.007	0.196	-0.326	0.200	1.000	0.607	0.430	0.279	0.218	0.064	0.619	0.799
avg_basket_size	0.025	-0.057	-0.179	0.036	0.607	1.000	0.088	-0.008	-0.035	-0.168	0.858	0.692
purchase_count	0.398	0.436	-0.575	0.733	0.430	0.088	1.000	0.688	0.631	-0.160	-0.001	0.625
charge_back_count	0.219	0.289	-0.329	0.365	0.279	-0.008	0.688	1.000	0.977	-0.050	-0.062	0.415
return_rate	0.214	0.233	-0.269	0.398	0.218	-0.035	0.631	0.977	1.000	-0.044	-0.091	0.340
avg_unt_price	-0.233	0.035	0.203	-0.149	0.064	-0.168	-0.160	-0.050	-0.044	1.000	0.197	0.079
avg_order_value	-0.095	-0.022	-0.067	-0.054	0.619	0.858	-0.001	-0.062	-0.091	0.197	1.000	0.723
gross_revenue	0.092	0.282	-0.425	0.332	0.799	0.692	0.625	0.415	0.340	0.079	0.723	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	customer_id	lifetime	recency	avg_purchase_interval	nunique_products	avg_basket_size	purchase_count	charge_back_count	return_rate	avg_unt_price	avg_order_value	gross_revenue
0	17850.0	373.0	372.0	10.657143	21.0	48.371429	35	1.0	0.028571	3.960370	151.103714	5288.63
1	13047.0	373.0	56.0	23.312500	105.0	84.687500	16	7.0	0.437500	3.926082	193.068750	3089.10
2	12583.0	373.0	2.0	21.941176	114.0	292.823529	17	2.0	0.117647	2.140474	389.961176	6629.34
3	13748.0	373.0	95.0	74.600000	24.0	87.800000	5	0.0	0.000000	3.996429	189.650000	948.25
4	15100.0	373.0	333.0	62.166667	1.0	9.666667	6	3.0	0.500000	10.950000	105.850000	635.10
5	15291.0	373.0	25.0	19.631579	61.0	109.105263	19	5.0	0.263158	4.702255	239.553158	4551.51
6	14688.0	373.0	7.0	13.814815	148.0	119.333333	27	6.0	0.222222	2.131040	189.162222	5107.38
7	17809.0	373.0	16.0	26.642857	46.0	144.000000	14	2.0	0.142857	2.905738	381.775000	5344.85
8	15311.0	373.0	0.0	3.161017	567.0	319.661017	118	27.0	0.228814	2.506036	503.553729	59419.34
9	16098.0	373.0	87.0	53.285714	34.0	87.571429	7	0.0	0.000000	4.424627	286.518571	2005.63

	customer_id	lifetime	recency	avg_purchase_interval	nunique_products	avg_basket_size	purchase_count	avg_unt_price	avg_order_value	gross_revenue
5696	-3701.0	1.0	1.0	1.0	55.0	1074.0	1	7.254516	4839.42	4839.42
5697	13298.0	1.0	1.0	1.0	2.0	96.0	1	3.750000	360.00	360.00
5698	14569.0	1.0	1.0	1.0	10.0	79.0	1	3.920000	227.39	227.39
5699	-3705.0	1.0	1.0	1.0	7.0	14.0	1	1.278571	17.90	17.90
5700	-3706.0	1.0	1.0	1.0	2.0	2.0	1	1.675000	3.35	3.35
5701	-3707.0	1.0	1.0	1.0	634.0	1747.0	1	4.320946	5699.00	5699.00
5702	-3708.0	0.0	0.0	1.0	730.0	2010.0	1	4.175904	6756.06	6756.06
5703	-3709.0	0.0	0.0	1.0	56.0	654.0	1	6.269661	3217.20	3217.20
5704	-3710.0	0.0	0.0	1.0	217.0	731.0	1	6.364378	3950.72	3950.72
5705	12713.0	0.0	0.0	1.0	37.0	505.0	1	2.084595	794.55	794.55

Overview

Variables

Interactions

Correlations

Missing values

Sample